package com.scse.bms.mapper;

import com.scse.bms.entity.PressDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Title: PressMapper
 * @Author: 吴赠禹
 * @Date: 2021/2/23 6:00
 * @Version: 1.0
 * @Description: TODO
 */

@Repository
@Mapper
public interface PressMapper {

    @Select("select id, name, img from t_press where  img <> '' ORDER BY RAND() limit 9;")
    List<PressDO> getPress(int count);


}
